NRANGE

The NRANGE field specifier (case sensitive) allows you to find documents in which a specified field contains a number that falls within the inclusive range of two specified numbers.

NOTE: You can optimize the field specifier speed by restricting the field to the NumericType property type.

Format

FieldText=NRANGE{yourNumbers}:yourFields
yourNumbers

Two numbers separated by a comma (there must be no space before or after the comma). A document returns only if one of yourFields contains a number that falls within the inclusive range of the specified numbers (including decimal numbers).

By default, the range is inclusive. You can use the greater than (<) and less than (>) symbols to specify an exclusive range. You can make either or both ends of the range exclusive.

yourFields One or more fields. A document returns only if it contains one of these fields, and if this field contains a number that falls within the inclusive range of yourNumbers. Separate multiple fields with colons (:). There must be no space before or after a colon.

Example

FieldText=NRANGE{1,99}:CODE

The CODE field must contain a number between 1 and 99 (inclusive) for this document to return.

FieldText=NRANGE{1234567890123,2345678901234}:ACCOUNT:KONTO

The ACCOUNT or KONTO field must contain a number between 1234567890123 and 2345678901234 (inclusive) for this document to return.

FieldText=NRANGE{36.5,42.3}:CODE

The CODE field must contain a number between 36.5 and 42.3 (inclusive) for this document to return.

FieldText=NRANGE{>1,5}:CODE

The CODE field must contain a value that is greater than 1, up to and including 5.